Lookup Tables

../../../../_images/lookup1.svg

Take rows from the lookup table in the order defined by the control table.

Documentation

Auto generated list version of Lookup Table.

In this version, the following ports from the original nodes have been changed to lists which the node loops over:

Looped Inputs

lookupee.

Looped Outputs

out.

For details see the original node.

Definition

Input ports

lookup

table

Lookup table

lookupee

[table]

Control table

Output ports

out

[table]

Result table

Configuration:
Lookup columns (template_columns)

A list storing columns in the lookup table used for matching. At each index there is a corresponding entry in lookupee_columns.

Control columns (lookupee_columns)

A list storing columns in the control table used for matching. At each index there is a corresponding entry in template_columns.

Event column (event_column)

Stores the index of the column pair which is to be matched as events, or -1 if no such column pair has been selected.

Require perfect match (perfect_match)

If checked, each row in the control table has to match exactly one row in the lookup table.

Use zero-like values instead of masks (nomasks)

When unchecked rows that can not be matched will be masked. When checked such rows are instead assigned 0, 0.0, False, “”, etc. depending on the type of the value column.

Copy input (copy_input)

Copy the columns from the control table to the output giving them priority over columns from lookup table in case of same column names.

class node_lookup_table.LookupTablesNode[source]

Related nodes